TrustRadius Insights
Vertica has become a crucial tool for businesses looking to analyze large volumes of data for various use cases. Users have found it …
Overview
What is OpenText Vertica?
The Vertica Analytics Platform supplies enterprise data warehouses with big data analytics capabilities and modernization. Vertica is owned and supported by OpenText.
Recent Reviews
Pricing
N/A
Unavailable
What is OpenText Vertica?
The Vertica Analytics Platform supplies enterprise data warehouses with big data analytics capabilities and modernization. Vertica is owned and supported by OpenText.
Entry-level set up fee?
- No setup fee
Offerings
- Free Trial
- Free/Freemium Version
- Premium Consulting/Integration Services
Would you like us to let the vendor know that you want pricing?
48 people also want pricing
Alternatives Pricing
What is ClicData?
ClicData is a 100% cloud-based business intelligence platform that allows users to connect, process, blend, visualize and share data from a single place. As an automated platform, users are able to rely on the latest version of company data, to ensure users make the right decisions. Hundreds of…
What is retailMetrix?
RetailMetrix is a data analytics platform for retailers with the mission of enabling retailers to get value from their data. RetailMatrix processes and stores sales, labor and customer data using data warehouse technologies. Its dashboards and reports allows team to find the data that matters to…
Product Demos
Vertica in-DB Machine Learning Demo
YouTube
How to recover a HP Vertica Database Node from a Corrupted Catalog
YouTube
Vertica Optimized for Multiple Clouds Using Attunity Replicate
YouTube
vertica and elastic search demo
YouTube
WEBINAR: Predictive Analytics with Vertica
YouTube
Utilizing Tableau and HP Vertica Demo - Consolidating Worksheets into a Single Dashboard
YouTube
Product Details
- About
- Tech Details
What is OpenText Vertica?
The Vertica Analytics Platform supplies enterprise data warehouses with big data analytics capabilities and modernization. Vertica is owned and supported by OpenText.
OpenText Vertica Video
Big Data has a big history. A history built upon many innovations and countless discoveries. Pushing humanity into new ways of thinking. New capabilities. A new way of seeing how the future can be. New ways of finding value in the massive amounts of data being created. And whe...
Show More OpenText Vertica Technical Details
| Operating Systems | Unspecified |
|---|---|
| Mobile Application | No |
Comparisons
Compare with
Reviews and Ratings
(29)
Community Insights
TrustRadius Insights are summaries of user sentiment data from TrustRadius reviews and, when necessary, 3rd-party data sources. Have feedback on this content? Let us know!
- Business Problems Solved
- Pros
- Cons
- Recommendations
Vertica has become a crucial tool for businesses looking to analyze large volumes of data for various use cases. Users have found it particularly valuable as a data warehouse for analyzing internal business data and marketing results of clients. Its ability to handle large data sizes enables analysis at a level that would not have been possible otherwise. Uber, for example, has successfully employed Vertica for their data analytics needs. Additionally, companies have created Vertica-based data marts to provide analytics insights and support data science across their entire organizations.
One key advantage of Vertica is its complementary nature with other technologies like Hadoop. By leveraging its high scale capabilities, Vertica enhances data efforts when used alongside Hadoop. The software also serves as the main data warehouse, acting as a source for analytic reports and facilitating data analysis activities. Interestingly, users have discovered non-traditional applications for Vertica, utilizing it as a powerful data processing engine to solve problems at scale. For instance, in the entertainment industry, Vertica is instrumental in rendering data and performing big data analysis tasks efficiently.
The speed of Vertica is highly beneficial to users, allowing them to quickly complete ad-hoc queries and conduct more in-depth analyses. This speed sets Vertica apart from competitors in the highly ingested, fast query analytics niche, including platforms like Teradata, Greenplum, Exadata, and Netezza. Moreover, Vertica excels in handling large amounts of data ingestion quickly, making it a reliable tool for organizations dealing with vast quantities of information.
Furthermore, Vertica serves as an analytics database that can handle real-time streaming data from sources like Apache Kafka. This capability enables organizations to gain near real-time customer insights for their consumer-facing web portals and mobile applications. Overall, users have come to rely on Vertica as an essential analytics database for reporting, ad-hoc queries, and more in-depth analyses across a wide range of industries and use cases.
Impressive Analytical Querying Capabilities: Several reviewers have praised Vertica for its impressive analytical querying capabilities. Users have found the built-in analytical functions to be powerful, allowing them to perform complex analyses across terabytes of data. This feature has enabled users to gain interesting insights and make data-driven decisions.
Efficient Data Ingestion: Many users have highlighted Vertica's efficient data ingestion process as a major advantage. According to reviewers, billions of rows can be easily sent to Vertica via the WOS system, and the data is ready for immediate use. This streamlined data ingestion process not only saves time but also enables quick analysis, enhancing productivity.
Scalability and Performance: The scalability and performance of Vertica have been widely appreciated by reviewers. Users have mentioned that Vertica can scale reasonably well up to 10-20 nodes and handle hundreds of terabytes of data effectively. Additionally, many reviewers consider Vertica as one of the fastest query engines available, with tables containing billions of rows still delivering speedy results for analytical tasks.
Deletion Process: Users have expressed frustration with the deletion process in Vertica, stating that it does not fully delete when prompted and can cause delays in other processes. Some users have reported this issue.
Permissions on Table Manipulation: Reviewers find the permissions on table manipulation lacking in Vertica, as only the owner of the table can edit its structure. This makes it difficult to set up true administrators who can maintain each other's work. Several users have mentioned this limitation.
Handling Petabyte-Scale Data: Vertica struggles to handle petabyte-scale data according to user feedback. It starts to crumble beyond hundreds of terabytes of data. Numerous reviewers have noted this scalability issue.
Users have made several recommendations based on their experience with Vertica. The most common recommendations are:
-
Proper Testing and Preparation: Users suggest that before releasing a major version of Vertica, it is crucial to have thorough testing in place. This ensures that any potential issues or bugs are identified and resolved prior to deployment.
-
Follow Vendor Configuration Instructions: It is advised to closely follow the vendor's configuration instructions when setting up Vertica. This helps ensure optimal performance and stability of the tool.
-
Training and Familiarity: Users recommend sending database administrators (DBAs) for training and studying the SQL limitations of Vertica. It is important to have a good understanding of Vertica and its capabilities to effectively leverage the tool for solving specific business problems.
It is important to note that while Vertica is highly recommended for data warehousing, solving Big Data solutions, and analytical data warehousing, users also suggest considering other database systems if there is not a significant amount of data that needs to be accessed quickly or if a more common/easier-to-set-up system would suffice.
Attribute Ratings
Reviews
(1-4 of 4)Companies can't remove reviews or game the system. Here's why
May 07, 2021
Robust Vertica Experience
It's used by couple of departments. I work in the entertainment industry, so it is used to deal with the rendering data. It is also used for big data analysis.
- After the initial setup and performance tuning phase, Vertica database cluster pretty much runs on its own. We haven't had too much maintenance to do.
- When we had to scale up the cluster from 6 nodes to 12 nodes, it was an easy task.
- At one time, because of some issues with a server, we had to take a node out and could do it on the fly.
- One time, one of the nodes wasn't coming up because of some ambiguity with the local data. Vertica wasn't able to fix it by itself and we were trying to remove the node out of the database and we couldn't do it. It would be great if that could be addressed. Luckily when we rebooted the whole server, some of the dead transaction got flushed because of which vertica was able to recover and the node came up.
- For the most part, I would say it's a positive impact as it helped the developers to build a better strategy for working with the rendering data.
We have been evaluating Greenplum comparing with Vertica.
December 15, 2019
Vertica Review
Vertica forms the analytics database that takes in realtime streaming data (from Apache Kafka) and is used to provide customer insights in near real-time. It is used for the consumer-facing web portal and mobile applications.
- It is able to intake real-time streaming data without much pre-processing and latency.
- Easy to integrate with real-time streaming ingestion engine.
- Vertica does not perform well when you have a lot of schemata.
- The management console including GUI is lacking features and can be improved with features that are typical of a database.
- Positive impact on ROI by being able to get customer insights in real-time.
- Positive ROI through reduced time to set-up and maintain Vertica instances.
- SAP HANA, MySQL, PostgreSQL, Oracle Data Warehouse, Snowflake, Google BigQuery and Cloudera Distribution Hadoop (CDH)
SAP HANA, Oracle, MySQL, and PostgreSQL are too heavyweight for achieving real-time latency requirements. Google BigQuery is limited to Cloud that makes hard to integrate with a large ingestion pipeline that may have both Cloud-based and on-prem components. Hadoop is much more complex to setup. Snowflake is again Cloud-based and is a new player so its reputation is not well known.
December 04, 2017
Analysis at Scale
Vertica is our data warehouse. We use it for analysis of our internal business as well as the marketing results of our clients. Due to the size of our data, without Vertica analysis at this level would not be possible.
- Analytical querying due to built in analytical functions that actually perform across TB of data.
- Ingestion of data. We can send billions of rows to Vertica easily via the WOS system and it is ready for use immediately.
- Efficient storage of data. What raw is TB of data, once ingested into Vertica only takes up GB of disk space.
- Management! The management console is intuitive and useful making keeping an eye on your cluster easier than any other product like this I have used.
- Deletion is tough in Vertica. Because one of our larger fact tables is rapidly changing we have a need to run purges on a regular basis. Those purges can take a day and delays the other processes while that is happening. It would be nice if when I hit delete, it really deleted.
- Permissions on table manipulation is a bit lacking. In order to edit a table structure you have to be the owner, ie the creator, of the table. It means setting up true administrators who can maintain each other's work is tough.
- For our internal business we have insights we could never have had without Vertica. We can actually see where our money is coming from and point our marketing and sales strategies in the correct direction thereby returning far more than we pay.
- For our customers we can offer services they had been begging for. Before implementing Vertica we had no insight on a client's marketing across all their activities because the data was just too large. Now, there is no question we can't answer.
MySQL and MS SQL Server are both fantastic RDBMS products. MS SQL Server goes a bit further since it has the builtin analytical functions. But it only scales so far. Once the data goes beyond capacity, getting results out just does not happen anymore. IBM Netezza and Teradata were both appliances that required different expertise than we had in house. Vertica was able to do the same, and in some cases better, on commodity hardware (frankly in our case old servers that were slated for recycling!) and at a small scale. In other words, Vertica we could grow slowly over time. Infobright is a great log processing database but for the functions we were looking to serve it just didn't have some of the features Vertica had that we felt were show stoppers.
December 08, 2015
Fast and powerful analytics platform
Vertica is our main data warehouse. Is used as a source for most of our analytic reports as well as for all data analysis activities. We also use it in a non-traditional fashion, more like a data processing engine for solving problems at scale (matching, statistics, correlate sources, etc.). It runs in AWS with data loaded/unloaded from/to S3.
- IO optimized - it's a columnar store, no indexing structures to maintain like traditional databases, the indexing is achieved by storing the data sorted on disk, which itself is run transparently as a background process.
- Reduced data storage footprint through advanced encoding schemas (RLE, common-delta, etc.) as well as compression algorithms ability to operate directly on the encoded data.
- Could use some work on better integrating with cloud providers and open source technologies. For AWS you will find an AMI in the marketplace and recently a connector for loading data from S3 directly was created. With last release, integration with Kafka was added that can help.
- Managing large workloads (concurrent queries) is a bit challenging.
- Having a way to provide an estimate on the duration for currently executing queries / etc. can be helpful. Vertica provides some counters for the query execution engine that are helpful but some may find confusing.
- Unloading data over JDBC is very slow. We've had to come up with alternatives based on vsql, etc. Not a very clean, official on how to unload data.
- Vertica increased our productivity in analyzing the data and validating simple proof of concepts with our data.
- Results of analytical queries produced from Vertica are used by all departments as well as part of some of our products.
Vertica is much easier to manage; is just software (i.e. vs. Netezza), easier to scale and extend, with a very powerful query execution engine and storage layer. While other solutions (e.g. Greenplum) are just postgres clones that were extended to run at scale but still keep their traditional database features (e.g. indexes, materialized views, etc), Vertica has been built from scratch with performance in mind. Five years ago Vertica's storage layer was pretty advanced with very few contenders. Currently more are copying it and lately you can find features like RLE (run length encoding), etc., even in open source columnar formats like Parquet, ORC. So in order to keep up, Vertica has been extended with Hadoop, Kafka, unstructured data (FlexTables) support, etc.